Page 53 - Data_Science_Part_A C12

• Name of the printer that is attached and is being used for printing.

• The range of pages to be printed that is all sheets or selected sheets.
• Number of copies to be printed.
• The page layout is to be selected that is page size or orientation.
Step 4: Click on the Print button and the sheet will be printed. Press Ctrl+P keys from the keyboard to print a file.

3.10 WORKING WITH DATA AND FORMATTING TEXT

Spreadsheets are versatile tools that allow data to be used for calculations, visual representations, and information
display. Let’s dive deeper into how to effectively work with data in a spreadsheet.

3.10.1 Formula

A formula is a mathematical expression that performs calculations using values, cell references, and operators. One of
the most important features of a spreadsheet package is the ability to perform calculations, for which formulas are used.
Formulas are entered to carry out mathematical operations such as addition, subtraction, multiplication, and division.
Entering a formula in a cell is a logical entry that shows the relationship between different cells. In LibreOffice Calc or
Excel, a formula always starts with an equal (=) sign. The formula applied in a particular cell can be viewed in the formula
bar when the specific cell is selected.
Formulas in Calc include the following:

3.10.2 Adding Values Directly
To calculate anything in a spreadsheet, start with the ‘=’ (equal-to) symbol. This informs the spreadsheet that a formula
is being entered, adds numbers directly, performs the calculation, and displays the result.

For example: Consider a spreadsheet that has the following details:
Step 1: Click on the cell where you want the result.
Step 2: Type =5+3+5+6+5.
Step 3: Press the Enter key. You will get the result; the result will be 24.

The Formula Bar displays the formula entered in the selected cell.

3.10.3 Adding Using Cell Address

Each cell in the sheet has a unique address that is formed by the intersection of its column and row, such as ‘A10’. Here,
‘A’ is the column name and ‘10’ is the row number.
Formulas are applied to cells on the basis of the cell address that displays the output as a result of calculation done
between data of different cell addresses.

ICT Skills-III 51